Pandas Profiling Report

Dataset statistics

Number of variables	23
Number of observations	52
Missing cells	441
Missing cells (%)	36.9%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	9.5 KiB
Average record size in memory	186.5 B

Variable types

Numeric	15
Unsupported	7
Categorical	1

Alerts

`Year` is highly overall correlated with `Natural gas` and 13 other fields	High correlation
`Natural gas` is highly overall correlated with `Year` and 14 other fields	High correlation
`Coal` is highly overall correlated with `Year` and 13 other fields	High correlation
`Hydroenergy` is highly overall correlated with `Year` and 13 other fields	High correlation
`Firewood` is highly overall correlated with `Year` and 13 other fields	High correlation
`Sugarcane and products` is highly overall correlated with `Year` and 14 other fields	High correlation
`Other Primary_x000d_` is highly overall correlated with `Year` and 14 other fields	High correlation
`Total Primaries` is highly overall correlated with `Year` and 13 other fields	High correlation
`Electricity` is highly overall correlated with `Year` and 13 other fields	High correlation
`Diesel oil` is highly overall correlated with `Year` and 13 other fields	High correlation
`Fuel oil` is highly overall correlated with `Natural gas` and 4 other fields	High correlation
`Gases` is highly overall correlated with `Year` and 13 other fields	High correlation
`Other secondary` is highly overall correlated with `Year` and 14 other fields	High correlation
`Total Secundaries` is highly overall correlated with `Year` and 13 other fields	High correlation
`Total` is highly overall correlated with `Year` and 13 other fields	High correlation
`Charcoal` is highly overall correlated with `Year` and 14 other fields	High correlation
`Oil` has 52 (100.0%) missing values	Missing
`Natural gas` has 20 (38.5%) missing values	Missing
`Nuclear` has 52 (100.0%) missing values	Missing
`LPG` has 52 (100.0%) missing values	Missing
`Gasoline/alcohol` has 52 (100.0%) missing values	Missing
`Kerosene/jet fuel` has 52 (100.0%) missing values	Missing
`Coke` has 52 (100.0%) missing values	Missing
`Charcoal` has 48 (92.3%) missing values	Missing
`Other secondary` has 9 (17.3%) missing values	Missing
`Non-energy` has 52 (100.0%) missing values	Missing
`Year` is uniformly distributed	Uniform
`Charcoal` is uniformly distributed	Uniform
`Year` has unique values	Unique
`Other Primary_x000d_` has unique values	Unique
`Total Primaries` has unique values	Unique
`Electricity` has unique values	Unique
`Diesel oil` has unique values	Unique
`Fuel oil` has unique values	Unique
`Total Secundaries` has unique values	Unique
`Total` has unique values	Unique
`Oil` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`Nuclear` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`LPG` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`Gasoline/alcohol` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`Kerosene/jet fuel` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`Coke` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`Non-energy` is an unsupported type, check if it needs cleaning or further analysis	Unsupported

Reproduction

Analysis started	2023-07-30 07:36:52.114014
Analysis finished	2023-07-30 07:37:52.984851
Duration	1 minute and 0.87 seconds
Software version	pandas-profiling v3.6.6
Download configuration	config.json

Year
Real number (ℝ)

HIGH CORRELATION UNIFORM UNIQUE

Distinct	52
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1995.5

Minimum	1970
Maximum	2021
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	548.0 B

Quantile statistics

Minimum	1970
5-th percentile	1972.55
Q1	1982.75
median	1995.5
Q3	2008.25
95-th percentile	2018.45
Maximum	2021
Range	51
Interquartile range (IQR)	25.5

Descriptive statistics

Standard deviation	15.154757
Coefficient of variation (CV)	0.0075944662
Kurtosis	-1.2
Mean	1995.5
Median Absolute Deviation (MAD)	13
Skewness	0
Sum	103766
Variance	229.66667
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1970	1	1.9%
1971	1	1.9%
1998	1	1.9%
1999	1	1.9%
2000	1	1.9%
2001	1	1.9%
2002	1	1.9%
2003	1	1.9%
2004	1	1.9%
2005	1	1.9%
Other values (42)	42	80.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1970	1	1.9%
1971	1	1.9%
1972	1	1.9%
1973	1	1.9%
1974	1	1.9%
1975	1	1.9%
1976	1	1.9%
1977	1	1.9%
1978	1	1.9%
1979	1	1.9%

Value	Count	Frequency (%)
2021	1	1.9%
2020	1	1.9%
2019	1	1.9%
2018	1	1.9%
2017	1	1.9%
2016	1	1.9%
2015	1	1.9%
2014	1	1.9%
2013	1	1.9%
2012	1	1.9%

Oil
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	52
Missing (%)	100.0%
Memory size	548.0 B

Natural gas
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	32
Distinct (%)	100.0%
Missing	20
Missing (%)	38.5%
Infinite	0
Infinite (%)	0.0%
Mean	-1436.1081

Minimum	-4527.85
Maximum	-67.93
Zeros	0
Zeros (%)	0.0%
Negative	32
Negative (%)	61.5%
Memory size	548.0 B

Quantile statistics

Minimum	-4527.85
5-th percentile	-3537.6145
Q1	-2403.9275
median	-1076.35
Q3	-279.75
95-th percentile	-114.739
Maximum	-67.93
Range	4459.92
Interquartile range (IQR)	2124.1775

Descriptive statistics

Standard deviation	1258.1109
Coefficient of variation (CV)	-0.87605583
Kurtosis	-0.15468776
Mean	-1436.1081
Median Absolute Deviation (MAD)	928.325
Skewness	-0.81838347
Sum	-45955.46
Variance	1582843
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=32)

Value	Count	Frequency (%)
-1140.11	1	1.9%
-4527.85	1	1.9%
-2941.63	1	1.9%
-2845.5	1	1.9%
-2757.27	1	1.9%
-2656.49	1	1.9%
-2699.72	1	1.9%
-2575.1	1	1.9%
-2311.98	1	1.9%
-2346.87	1	1.9%
Other values (22)	22	42.3%
(Missing)	20	38.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-4527.85	1	1.9%
-4266.04	1	1.9%
-2941.63	1	1.9%
-2845.5	1	1.9%
-2757.27	1	1.9%
-2699.72	1	1.9%
-2656.49	1	1.9%
-2575.1	1	1.9%
-2346.87	1	1.9%
-2325.54	1	1.9%

Value	Count	Frequency (%)
-67.93	1	1.9%
-78.56	1	1.9%
-144.34	1	1.9%
-147.55	1	1.9%
-148.5	1	1.9%
-174.91	1	1.9%
-218.21	1	1.9%
-230.73	1	1.9%
-296.09	1	1.9%
-463.12	1	1.9%

Coal
Real number (ℝ)

Distinct	51
Distinct (%)	98.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-81.06

Minimum	-288.07
Maximum	-9.05
Zeros	0
Zeros (%)	0.0%
Negative	52
Negative (%)	100.0%
Memory size	548.0 B

Quantile statistics

Minimum	-288.07
5-th percentile	-264.5105
Q1	-109.3425
median	-47.445
Q3	-18.9675
95-th percentile	-10.4115
Maximum	-9.05
Range	279.02
Interquartile range (IQR)	90.375

Descriptive statistics

Standard deviation	84.703408
Coefficient of variation (CV)	-1.0449471
Kurtosis	0.2575377
Mean	-81.06
Median Absolute Deviation (MAD)	32.225
Skewness	-1.2542131
Sum	-4215.12
Variance	7174.6674
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-13.83	2	3.8%
-9.59	1	1.9%
-42.89	1	1.9%
-76.27	1	1.9%
-62.82	1	1.9%
-65.02	1	1.9%
-48.65	1	1.9%
-35.79	1	1.9%
-46.14	1	1.9%
-52.67	1	1.9%
Other values (41)	41	78.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-288.07	1	1.9%
-285.42	1	1.9%
-273.91	1	1.9%
-256.82	1	1.9%
-237.44	1	1.9%
-215.78	1	1.9%
-209.66	1	1.9%
-202.88	1	1.9%
-183.62	1	1.9%
-175.41	1	1.9%

Value	Count	Frequency (%)
-9.05	1	1.9%
-9.59	1	1.9%
-10.12	1	1.9%
-10.65	1	1.9%
-11.18	1	1.9%
-11.56	1	1.9%
-11.96	1	1.9%
-12.25	1	1.9%
-13.83	2	3.8%
-16.61	1	1.9%

Hydroenergy
Real number (ℝ)

Distinct	51
Distinct (%)	98.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-746.98885

Minimum	-1948.39
Maximum	-114.51
Zeros	0
Zeros (%)	0.0%
Negative	52
Negative (%)	100.0%
Memory size	548.0 B

Quantile statistics

Minimum	-1948.39
5-th percentile	-1862.7565
Q1	-1325.7575
median	-339.995
Q3	-240.0375
95-th percentile	-131.5055
Maximum	-114.51
Range	1833.88
Interquartile range (IQR)	1085.72

Descriptive statistics

Standard deviation	646.90677
Coefficient of variation (CV)	-0.86601932
Kurtosis	-1.1922437
Mean	-746.98885
Median Absolute Deviation (MAD)	169.355
Skewness	-0.7188987
Sum	-38843.42
Variance	418488.37
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-261.42	2	3.8%
-119.23	1	1.9%
-376.16	1	1.9%
-488.54	1	1.9%
-502.04	1	1.9%
-447.97	1	1.9%
-1008.07	1	1.9%
-1000.78	1	1.9%
-1047.71	1	1.9%
-1061.18	1	1.9%
Other values (41)	41	78.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-1948.39	1	1.9%
-1897.54	1	1.9%
-1894.42	1	1.9%
-1836.85	1	1.9%
-1807.08	1	1.9%
-1774.97	1	1.9%
-1760.69	1	1.9%
-1666.62	1	1.9%
-1658.27	1	1.9%
-1657.23	1	1.9%

Value	Count	Frequency (%)
-114.51	1	1.9%
-119.23	1	1.9%
-124.13	1	1.9%
-137.54	1	1.9%
-145.97	1	1.9%
-163.33	1	1.9%
-191.79	1	1.9%
-223.25	1	1.9%
-225.92	1	1.9%
-229.53	1	1.9%

Nuclear
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	52
Missing (%)	100.0%
Memory size	548.0 B

Firewood
Real number (ℝ)

Distinct	51
Distinct (%)	98.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-159.25827

Minimum	-387.2
Maximum	-12.7
Zeros	0
Zeros (%)	0.0%
Negative	52
Negative (%)	100.0%
Memory size	548.0 B

Quantile statistics

Minimum	-387.2
5-th percentile	-368.7105
Q1	-229.6775
median	-136.985
Q3	-80.65
95-th percentile	-15.6915
Maximum	-12.7
Range	374.5
Interquartile range (IQR)	149.0275

Descriptive statistics

Standard deviation	113.14437
Coefficient of variation (CV)	-0.71044579
Kurtosis	-0.64940494
Mean	-159.25827
Median Absolute Deviation (MAD)	79.005
Skewness	-0.58098771
Sum	-8281.43
Variance	12801.648
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-114.65	2	3.8%
-12.7	1	1.9%
-141.86	1	1.9%
-164.05	1	1.9%
-172.44	1	1.9%
-132.34	1	1.9%
-131.53	1	1.9%
-127.14	1	1.9%
-117.82	1	1.9%
-127.24	1	1.9%
Other values (41)	41	78.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-387.2	1	1.9%
-383.67	1	1.9%
-373.38	1	1.9%
-364.89	1	1.9%
-353.48	1	1.9%
-347.58	1	1.9%
-333.34	1	1.9%
-309.93	1	1.9%
-307.95	1	1.9%
-294.11	1	1.9%

Value	Count	Frequency (%)
-12.7	1	1.9%
-13.32	1	1.9%
-15.18	1	1.9%
-16.11	1	1.9%
-16.73	1	1.9%
-18.28	1	1.9%
-21.69	1	1.9%
-22	1	1.9%
-27.27	1	1.9%
-28.51	1	1.9%

Sugarcane and products
Real number (ℝ)

Distinct	50
Distinct (%)	96.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-1775.4169

Minimum	-6570.86
Maximum	-88.99
Zeros	0
Zeros (%)	0.0%
Negative	52
Negative (%)	100.0%
Memory size	548.0 B

Quantile statistics

Minimum	-6570.86
5-th percentile	-6131.145
Q1	-2224.2175
median	-628.12
Q3	-333.375
95-th percentile	-109.135
Maximum	-88.99
Range	6481.87
Interquartile range (IQR)	1890.8425

Descriptive statistics

Standard deviation	2184.3351
Coefficient of variation (CV)	-1.2303224
Kurtosis	-0.10412283
Mean	-1775.4169
Median Absolute Deviation (MAD)	482.61
Skewness	-1.2383219
Sum	-92321.68
Variance	4771319.9
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-106.44	2	3.8%
-111.34	2	3.8%
-2689.06	1	1.9%
-873.26	1	1.9%
-735.31	1	1.9%
-937.97	1	1.9%
-1075.5	1	1.9%
-1370.98	1	1.9%
-1406.46	1	1.9%
-1550.99	1	1.9%
Other values (40)	40	76.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-6570.86	1	1.9%
-6240.7	1	1.9%
-6150.89	1	1.9%
-6114.99	1	1.9%
-6076.45	1	1.9%
-5964.74	1	1.9%
-5782.78	1	1.9%
-5677.79	1	1.9%
-5270.09	1	1.9%
-4431.47	1	1.9%

Value	Count	Frequency (%)
-88.99	1	1.9%
-106.44	2	3.8%
-111.34	2	3.8%
-115.81	1	1.9%
-123.05	1	1.9%
-167.97	1	1.9%
-186.28	1	1.9%
-208.42	1	1.9%
-218.85	1	1.9%
-238.86	1	1.9%

Other Primary_x000d_
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	52
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-1475.4065

Minimum	-5688.41
Maximum	-79.87
Zeros	0
Zeros (%)	0.0%
Negative	52
Negative (%)	100.0%
Memory size	548.0 B

Quantile statistics

Minimum	-5688.41
5-th percentile	-4516.4535
Q1	-2168.135
median	-786.375
Q3	-329.8225
95-th percentile	-91.123
Maximum	-79.87
Range	5608.54
Interquartile range (IQR)	1838.3125

Descriptive statistics

Standard deviation	1512.2697
Coefficient of variation (CV)	-1.0249851
Kurtosis	0.44828478
Mean	-1475.4065
Median Absolute Deviation (MAD)	685.135
Skewness	-1.2008412
Sum	-76721.14
Variance	2286959.6
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-81.16	1	1.9%
-79.87	1	1.9%
-917.86	1	1.9%
-1081.34	1	1.9%
-1439.07	1	1.9%
-1566.21	1	1.9%
-1683.26	1	1.9%
-1731.85	1	1.9%
-1827.21	1	1.9%
-2166.63	1	1.9%
Other values (42)	42	80.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-5688.41	1	1.9%
-4917.23	1	1.9%
-4601.06	1	1.9%
-4447.23	1	1.9%
-4294.23	1	1.9%
-4137.63	1	1.9%
-3884.28	1	1.9%
-3710.9	1	1.9%
-2895.59	1	1.9%
-2615.38	1	1.9%

Value	Count	Frequency (%)
-79.87	1	1.9%
-81.16	1	1.9%
-88.45	1	1.9%
-93.31	1	1.9%
-94.16	1	1.9%
-95.02	1	1.9%
-107.46	1	1.9%
-107.6	1	1.9%
-119.9	1	1.9%
-185.06	1	1.9%

Total Primaries
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	52
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-5121.8902

Minimum	-18135.05
Maximum	-311.67
Zeros	0
Zeros (%)	0.0%
Negative	52
Negative (%)	100.0%
Memory size	548.0 B

Quantile statistics

Minimum	-18135.05
5-th percentile	-15894.821
Q1	-7297.07
median	-2161.925
Q3	-1031.6625
95-th percentile	-357.76
Maximum	-311.67
Range	17823.38
Interquartile range (IQR)	6265.4075

Descriptive statistics

Standard deviation	5623.6329
Coefficient of variation (CV)	-1.0979605
Kurtosis	-0.19701289
Mean	-5121.8902
Median Absolute Deviation (MAD)	1733.125
Skewness	-1.1212061
Sum	-266338.29
Variance	31625247
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-311.67	1	1.9%
-326.39	1	1.9%
-2649.95	1	1.9%
-3146.59	1	1.9%
-3476.54	1	1.9%
-3854.83	1	1.9%
-4709.19	1	1.9%
-5145.95	1	1.9%
-5515.28	1	1.9%
-6116.88	1	1.9%
Other values (42)	42	80.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-18135.05	1	1.9%
-17699.18	1	1.9%
-15949.15	1	1.9%
-15850.37	1	1.9%
-15401.83	1	1.9%
-15353.21	1	1.9%
-14946.73	1	1.9%
-14369.04	1	1.9%
-12803.3	1	1.9%
-11573.34	1	1.9%

Value	Count	Frequency (%)
-311.67	1	1.9%
-326.39	1	1.9%
-356	1	1.9%
-359.2	1	1.9%
-379.18	1	1.9%
-407.03	1	1.9%
-450.57	1	1.9%
-534.65	1	1.9%
-586.45	1	1.9%
-678.91	1	1.9%

Electricity
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	52
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3039.7402

Minimum	318.85
Maximum	9776.97
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	548.0 B

Quantile statistics

Minimum	318.85
5-th percentile	364.6075
Q1	785.9
median	1412.715
Q3	4510.8875
95-th percentile	8725.717
Maximum	9776.97
Range	9458.12
Interquartile range (IQR)	3724.9875

Descriptive statistics

Standard deviation	3052.0675
Coefficient of variation (CV)	1.0040554
Kurtosis	-0.39916066
Mean	3039.7402
Median Absolute Deviation (MAD)	958.43
Skewness	1.0459479
Sum	158066.49
Variance	9315116.2
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
318.85	1	1.9%
322.54	1	1.9%
1765.29	1	1.9%
2066.18	1	1.9%
2150	1	1.9%
2337.49	1	1.9%
2921.99	1	1.9%
3058.27	1	1.9%
3252.35	1	1.9%
3406.94	1	1.9%
Other values (42)	42	80.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
318.85	1	1.9%
322.54	1	1.9%
349.62	1	1.9%
376.87	1	1.9%
394.67	1	1.9%
435.67	1	1.9%
472.9	1	1.9%
509.6	1	1.9%
584.48	1	1.9%
674.66	1	1.9%

Value	Count	Frequency (%)
9776.97	1	1.9%
9776.54	1	1.9%
8783.28	1	1.9%
8678.62	1	1.9%
8453.22	1	1.9%
8422.51	1	1.9%
8311.41	1	1.9%
8085.36	1	1.9%
7413.7	1	1.9%
6713.85	1	1.9%

LPG
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	52
Missing (%)	100.0%
Memory size	548.0 B

Gasoline/alcohol
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	52
Missing (%)	100.0%
Memory size	548.0 B

Kerosene/jet fuel
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	52
Missing (%)	100.0%
Memory size	548.0 B

Diesel oil
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	52
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-199.255

Minimum	-574.53
Maximum	-15.43
Zeros	0
Zeros (%)	0.0%
Negative	52
Negative (%)	100.0%
Memory size	548.0 B

Quantile statistics

Minimum	-574.53
5-th percentile	-444.8685
Q1	-307.2875
median	-136.95
Q3	-84.455
95-th percentile	-22.547
Maximum	-15.43
Range	559.1
Interquartile range (IQR)	222.8325

Descriptive statistics

Standard deviation	146.90744
Coefficient of variation (CV)	-0.73728359
Kurtosis	-0.22687325
Mean	-199.255
Median Absolute Deviation (MAD)	76.08
Skewness	-0.81438961
Sum	-10361.26
Variance	21581.796
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-77.16	1	1.9%
-57.44	1	1.9%
-239.42	1	1.9%
-328.58	1	1.9%
-364.04	1	1.9%
-501.15	1	1.9%
-216.66	1	1.9%
-155.73	1	1.9%
-160.73	1	1.9%
-168.42	1	1.9%
Other values (42)	42	80.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-574.53	1	1.9%
-561.98	1	1.9%
-501.15	1	1.9%
-398.82	1	1.9%
-390.39	1	1.9%
-381.46	1	1.9%
-380.85	1	1.9%
-378.37	1	1.9%
-370.34	1	1.9%
-364.04	1	1.9%

Value	Count	Frequency (%)
-15.43	1	1.9%
-16.29	1	1.9%
-19.72	1	1.9%
-24.86	1	1.9%
-57.44	1	1.9%
-64.3	1	1.9%
-67.7	1	1.9%
-68.59	1	1.9%
-71.16	1	1.9%
-72.49	1	1.9%

Fuel oil
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	52
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-338.79942

Minimum	-521.58
Maximum	-201.14
Zeros	0
Zeros (%)	0.0%
Negative	52
Negative (%)	100.0%
Memory size	548.0 B

Quantile statistics

Minimum	-521.58
5-th percentile	-447.1705
Q1	-396.0325
median	-340.815
Q3	-266.63
95-th percentile	-227.025
Maximum	-201.14
Range	320.44
Interquartile range (IQR)	129.4025

Descriptive statistics

Standard deviation	78.609409
Coefficient of variation (CV)	-0.23202344
Kurtosis	-0.65850716
Mean	-338.79942
Median Absolute Deviation (MAD)	60.98
Skewness	-0.18404824
Sum	-17617.57
Variance	6179.4392
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-329.53	1	1.9%
-245.76	1	1.9%
-456.13	1	1.9%
-413.45	1	1.9%
-362.22	1	1.9%
-395.15	1	1.9%
-373.8	1	1.9%
-305.84	1	1.9%
-295.96	1	1.9%
-298.37	1	1.9%
Other values (42)	42	80.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-521.58	1	1.9%
-512.28	1	1.9%
-456.13	1	1.9%
-439.84	1	1.9%
-439.13	1	1.9%
-437	1	1.9%
-422.79	1	1.9%
-417.59	1	1.9%
-416.3	1	1.9%
-413.45	1	1.9%

Value	Count	Frequency (%)
-201.14	1	1.9%
-203.6	1	1.9%
-225.32	1	1.9%
-228.42	1	1.9%
-235.65	1	1.9%
-238.18	1	1.9%
-245.76	1	1.9%
-251.25	1	1.9%
-251.81	1	1.9%
-253	1	1.9%

Coke
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	52
Missing (%)	100.0%
Memory size	548.0 B

Charcoal
Categorical

HIGH CORRELATION MISSING UNIFORM

Distinct	4
Distinct (%)	100.0%
Missing	48
Missing (%)	92.3%
Memory size	548.0 B

-15.4	1
-15.16	1
-8.81	1
-24.41	1

Length

Max length	6
Median length	5.5
Mean length	5.5
Min length	5

Characters and Unicode

Total characters	22
Distinct characters	8
Distinct categories	3 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	4 ?
Unique (%)	100.0%

Sample

1st row	-15.4
2nd row	-15.16
3rd row	-8.81
4th row	-24.41

Common Values

Value	Count	Frequency (%)
-15.4	1	1.9%
-15.16	1	1.9%
-8.81	1	1.9%
-24.41	1	1.9%
(Missing)	48	92.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
15.4	1	25.0%
15.16	1	25.0%
8.81	1	25.0%
24.41	1	25.0%

Most occurring characters

Value	Count	Frequency (%)
1	5	22.7%
-	4	18.2%
.	4	18.2%
4	3	13.6%
5	2	9.1%
8	2	9.1%
6	1	4.5%
2	1	4.5%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	14	63.6%
Dash Punctuation	4	18.2%
Other Punctuation	4	18.2%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	5	35.7%
4	3	21.4%
5	2	14.3%
8	2	14.3%
6	1	7.1%
2	1	7.1%

Dash Punctuation

Value	Count	Frequency (%)
-	4	100.0%

Other Punctuation

Value	Count	Frequency (%)
.	4	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	22	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	5	22.7%
-	4	18.2%
.	4	18.2%
4	3	13.6%
5	2	9.1%
8	2	9.1%
6	1	4.5%
2	1	4.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	22	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	5	22.7%
-	4	18.2%
.	4	18.2%
4	3	13.6%
5	2	9.1%
8	2	9.1%
6	1	4.5%
2	1	4.5%

Gases
Real number (ℝ)

Distinct	50
Distinct (%)	96.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-159.26192

Minimum	-553.45
Maximum	-9.46
Zeros	0
Zeros (%)	0.0%
Negative	52
Negative (%)	100.0%
Memory size	548.0 B

Quantile statistics

Minimum	-553.45
5-th percentile	-369.983
Q1	-264.86
median	-117.77
Q3	-58.675
95-th percentile	-9.933
Maximum	-9.46
Range	543.99
Interquartile range (IQR)	206.185

Descriptive statistics

Standard deviation	129.08491
Coefficient of variation (CV)	-0.81051958
Kurtosis	0.21227913
Mean	-159.26192
Median Absolute Deviation (MAD)	75.43
Skewness	-0.90925872
Sum	-8281.62
Variance	16662.913
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-9.46	3	5.8%
-335.92	1	1.9%
-185.26	1	1.9%
-167.63	1	1.9%
-180.53	1	1.9%
-188.26	1	1.9%
-131.53	1	1.9%
-141.47	1	1.9%
-109.77	1	1.9%
-139.56	1	1.9%
Other values (40)	40	76.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-553.45	1	1.9%
-394.47	1	1.9%
-381.17	1	1.9%
-360.83	1	1.9%
-349.33	1	1.9%
-349.19	1	1.9%
-335.92	1	1.9%
-334.39	1	1.9%
-315.65	1	1.9%
-311.33	1	1.9%

Value	Count	Frequency (%)
-9.46	3	5.8%
-10.32	1	1.9%
-10.75	1	1.9%
-12.47	1	1.9%
-27.08	1	1.9%
-30.95	1	1.9%
-32.24	1	1.9%
-36.11	1	1.9%
-37.4	1	1.9%
-47.71	1	1.9%

Other secondary
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	42
Distinct (%)	97.7%
Missing	9
Missing (%)	17.3%
Infinite	0
Infinite (%)	0.0%
Mean	-294.6014

Minimum	-747.32
Maximum	-0.88
Zeros	0
Zeros (%)	0.0%
Negative	43
Negative (%)	82.7%
Memory size	548.0 B

Quantile statistics

Minimum	-747.32
5-th percentile	-605.945
Q1	-492.7
median	-310.32
Q3	-52.495
95-th percentile	-8.06
Maximum	-0.88
Range	746.44
Interquartile range (IQR)	440.205

Descriptive statistics

Standard deviation	217.69612
Coefficient of variation (CV)	-0.73895141
Kurtosis	-1.1532206
Mean	-294.6014
Median Absolute Deviation (MAD)	230.88
Skewness	-0.13345524
Sum	-12667.86
Variance	47391.599
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=42)

Value	Count	Frequency (%)
-12.37	2	3.8%
-440.62	1	1.9%
-310.32	1	1.9%
-372.79	1	1.9%
-264.04	1	1.9%
-335.36	1	1.9%
-346.66	1	1.9%
-572.78	1	1.9%
-366.33	1	1.9%
-465.4	1	1.9%
Other values (32)	32	61.5%
(Missing)	9	17.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-747.32	1	1.9%
-623.14	1	1.9%
-609.21	1	1.9%
-576.56	1	1.9%
-572.78	1	1.9%
-571.18	1	1.9%
-555.25	1	1.9%
-551.3	1	1.9%
-541.2	1	1.9%
-528.73	1	1.9%

Value	Count	Frequency (%)
-0.88	1	1.9%
-2.63	1	1.9%
-7.97	1	1.9%
-8.87	1	1.9%
-12.37	2	3.8%
-29.54	1	1.9%
-30.89	1	1.9%
-48.7	1	1.9%
-49.53	1	1.9%
-52.09	1	1.9%

Non-energy
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	52
Missing (%)	100.0%
Memory size	548.0 B

Total Secundaries
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	52
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3039.7402

Minimum	318.85
Maximum	9776.97
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	548.0 B

Quantile statistics

Minimum	318.85
5-th percentile	364.6075
Q1	785.9
median	1412.715
Q3	4510.8875
95-th percentile	8725.717
Maximum	9776.97
Range	9458.12
Interquartile range (IQR)	3724.9875

Descriptive statistics

Standard deviation	3052.0675
Coefficient of variation (CV)	1.0040554
Kurtosis	-0.39916066
Mean	3039.7402
Median Absolute Deviation (MAD)	958.43
Skewness	1.0459479
Sum	158066.49
Variance	9315116.2
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
318.85	1	1.9%
322.54	1	1.9%
1765.29	1	1.9%
2066.18	1	1.9%
2150	1	1.9%
2337.49	1	1.9%
2921.99	1	1.9%
3058.27	1	1.9%
3252.35	1	1.9%
3406.94	1	1.9%
Other values (42)	42	80.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
318.85	1	1.9%
322.54	1	1.9%
349.62	1	1.9%
376.87	1	1.9%
394.67	1	1.9%
435.67	1	1.9%
472.9	1	1.9%
509.6	1	1.9%
584.48	1	1.9%
674.66	1	1.9%

Value	Count	Frequency (%)
9776.97	1	1.9%
9776.54	1	1.9%
8783.28	1	1.9%
8678.62	1	1.9%
8453.22	1	1.9%
8422.51	1	1.9%
8311.41	1	1.9%
8085.36	1	1.9%
7413.7	1	1.9%
6713.85	1	1.9%

Total
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	52
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-3024.3035

Minimum	-10042.21
Maximum	-316.51
Zeros	0
Zeros (%)	0.0%
Negative	52
Negative (%)	100.0%
Memory size	548.0 B

Quantile statistics

Minimum	-10042.21
5-th percentile	-8582.494
Q1	-4387.175
median	-1665.775
Q3	-758.4775
95-th percentile	-366.1815
Maximum	-316.51
Range	9725.7
Interquartile range (IQR)	3628.6975

Descriptive statistics

Standard deviation	2964.1207
Coefficient of variation (CV)	-0.9801003
Kurtosis	-0.18881415
Mean	-3024.3035
Median Absolute Deviation (MAD)	1258.115
Skewness	-1.085069
Sum	-157263.78
Variance	8786011.8
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-408.96	1	1.9%
-316.51	1	1.9%
-1958.29	1	1.9%
-2318.31	1	1.9%
-2565.57	1	1.9%
-2974.54	1	1.9%
-2927.03	1	1.9%
-2991.09	1	1.9%
-3233.88	1	1.9%
-3565.93	1	1.9%
Other values (42)	42	80.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-10042.21	1	1.9%
-9655.28	1	1.9%
-8619.3	1	1.9%
-8552.38	1	1.9%
-8499.52	1	1.9%
-8297.02	1	1.9%
-8215.07	1	1.9%
-7872.39	1	1.9%
-6965.01	1	1.9%
-6387.19	1	1.9%

Value	Count	Frequency (%)
-316.51	1	1.9%
-344.31	1	1.9%
-356.21	1	1.9%
-374.34	1	1.9%
-403.26	1	1.9%
-406.36	1	1.9%
-408.96	1	1.9%
-461.44	1	1.9%
-490.93	1	1.9%
-587.68	1	1.9%

Auto

Heatmap
Table

	Year	Natural gas	Coal	Hydroenergy	Firewood	Sugarcane and products	Other Primary_x000d_	Total Primaries	Electricity	Diesel oil	Fuel oil	Gases	Other secondary	Total Secundaries	Total	Charcoal
Year	1.000	-0.989	-0.924	-0.962	-0.935	-0.994	-0.994	-0.999	0.999	-0.930	0.498	-0.939	-0.948	0.999	-0.996	1.000
Natural gas	-0.989	1.000	0.733	0.876	0.728	0.978	0.974	0.988	-0.988	0.753	-0.907	0.808	0.886	-0.988	0.984	1.000
Coal	-0.924	0.733	1.000	0.870	0.949	0.919	0.919	0.923	-0.926	0.863	-0.392	0.869	0.850	-0.926	0.923	1.000
Hydroenergy	-0.962	0.876	0.870	1.000	0.876	0.963	0.954	0.961	-0.962	0.904	-0.474	0.907	0.919	-0.962	0.956	1.000
Firewood	-0.935	0.728	0.949	0.876	1.000	0.924	0.930	0.934	-0.935	0.886	-0.417	0.922	0.839	-0.935	0.933	1.000
Sugarcane and products	-0.994	0.978	0.919	0.963	0.924	1.000	0.988	0.994	-0.995	0.922	-0.501	0.925	0.944	-0.995	0.990	1.000
Other Primary_x000d_\n	-0.994	0.974	0.919	0.954	0.930	0.988	1.000	0.997	-0.994	0.928	-0.502	0.942	0.944	-0.994	0.997	1.000
Total Primaries	-0.999	0.988	0.923	0.961	0.934	0.994	0.997	1.000	-0.999	0.928	-0.499	0.938	0.947	-0.999	0.997	1.000
Electricity	0.999	-0.988	-0.926	-0.962	-0.935	-0.995	-0.994	-0.999	1.000	-0.928	0.495	-0.935	-0.948	1.000	-0.995	1.000
Diesel oil	-0.930	0.753	0.863	0.904	0.886	0.922	0.928	0.928	-0.928	1.000	-0.434	0.891	0.904	-0.928	0.932	1.000
Fuel oil	0.498	-0.907	-0.392	-0.474	-0.417	-0.501	-0.502	-0.499	0.495	-0.434	1.000	-0.479	-0.701	0.495	-0.494	1.000
Gases	-0.939	0.808	0.869	0.907	0.922	0.925	0.942	0.938	-0.935	0.891	-0.479	1.000	0.876	-0.935	0.942	1.000
Other secondary	-0.948	0.886	0.850	0.919	0.839	0.944	0.944	0.947	-0.948	0.904	-0.701	0.876	1.000	-0.948	0.952	1.000
Total Secundaries	0.999	-0.988	-0.926	-0.962	-0.935	-0.995	-0.994	-0.999	1.000	-0.928	0.495	-0.935	-0.948	1.000	-0.995	1.000
Total	-0.996	0.984	0.923	0.956	0.933	0.990	0.997	0.997	-0.995	0.932	-0.494	0.942	0.952	-0.995	1.000	1.000
Charcoal	1.000	1.000	1.000	1.000	1.000	1.000	1.000	1.000	1.000	1.000	1.000	1.000	1.000	1.000	1.000	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

451	Year	Oil	Natural gas	Coal	Hydroenergy	Nuclear	Firewood	Sugarcane and products	Other Primary_x000d_	Total Primaries	Electricity	LPG	Gasoline/alcohol	Kerosene/jet fuel	Diesel oil	Fuel oil	Coke	Charcoal	Gases	Other secondary	Non-energy	Total Secundaries	Total
1	1970	NaN	NaN	-9.59	-119.23	NaN	-12.70	-88.99	-81.16	-311.67	318.85	NaN	NaN	NaN	-77.16	-329.53	NaN	NaN	-9.46	NaN	NaN	318.85	-408.96
2	1971	NaN	NaN	-12.25	-114.51	NaN	-13.32	-106.44	-79.87	-326.39	322.54	NaN	NaN	NaN	-57.44	-245.76	NaN	NaN	-9.46	NaN	NaN	322.54	-316.51
3	1972	NaN	NaN	-11.18	-124.13	NaN	-15.18	-111.34	-94.16	-356.00	349.62	NaN	NaN	NaN	-64.30	-264.17	NaN	NaN	-9.46	NaN	NaN	349.62	-344.31
4	1973	NaN	NaN	-10.65	-137.54	NaN	-16.11	-106.44	-88.45	-359.20	376.87	NaN	NaN	NaN	-68.59	-294.55	NaN	NaN	-10.75	NaN	NaN	376.87	-356.21
5	1974	NaN	NaN	-10.12	-145.97	NaN	-16.73	-111.34	-95.02	-379.18	394.67	NaN	NaN	NaN	-71.16	-308.36	NaN	NaN	-10.32	NaN	NaN	394.67	-374.34
6	1975	NaN	NaN	-9.05	-163.33	NaN	-18.28	-123.05	-93.31	-407.03	435.67	NaN	NaN	NaN	-78.87	-340.57	NaN	NaN	-12.47	NaN	NaN	435.67	-403.26
7	1976	NaN	NaN	-13.83	-191.79	NaN	-21.69	-115.81	-107.46	-450.57	472.90	NaN	NaN	NaN	-16.29	-385.31	NaN	NaN	-27.08	NaN	NaN	472.90	-406.36
8	1977	NaN	NaN	-13.83	-223.25	NaN	-22.00	-167.97	-107.60	-534.65	509.60	NaN	NaN	NaN	-15.43	-390.01	NaN	NaN	-30.95	NaN	NaN	509.60	-461.44
9	1978	NaN	NaN	-16.61	-236.41	NaN	-27.27	-186.28	-119.90	-586.45	584.48	NaN	NaN	NaN	-19.72	-437.00	NaN	NaN	-32.24	NaN	NaN	584.48	-490.93
10	1979	NaN	NaN	-20.58	-225.92	NaN	-28.51	-218.85	-185.06	-678.91	674.66	NaN	NaN	NaN	-24.86	-521.58	NaN	NaN	-36.11	-0.88	NaN	674.66	-587.68

451	Year	Oil	Natural gas	Coal	Hydroenergy	Nuclear	Firewood	Sugarcane and products	Other Primary_x000d_	Total Primaries	Electricity	LPG	Gasoline/alcohol	Kerosene/jet fuel	Diesel oil	Fuel oil	Coke	Charcoal	Gases	Other secondary	Non-energy	Total Secundaries	Total
43	2012	NaN	-2346.87	-161.11	-1760.69	NaN	-257.81	-4431.47	-2615.38	-11573.34	6713.85	NaN	NaN	NaN	-390.39	-286.40	NaN	NaN	-274.35	-576.56	NaN	6713.85	-6387.19
44	2013	NaN	-2311.98	-158.16	-1897.54	NaN	-269.94	-5270.09	-2895.59	-12803.30	7413.70	NaN	NaN	NaN	-300.19	-264.59	NaN	NaN	-263.30	-747.32	NaN	7413.70	-6965.01
45	2014	NaN	-2575.10	-202.88	-1894.42	NaN	-307.95	-5677.79	-3710.90	-14369.04	8085.36	NaN	NaN	NaN	-378.37	-251.81	NaN	NaN	-349.33	-609.21	NaN	8085.36	-7872.39
46	2015	NaN	-2699.72	-237.44	-1807.08	NaN	-353.48	-5964.74	-3884.28	-14946.73	8311.41	NaN	NaN	NaN	-398.82	-251.25	NaN	NaN	-306.54	-623.14	NaN	8311.41	-8215.07
47	2016	NaN	-2656.49	-273.91	-1836.85	NaN	-333.34	-6114.99	-4137.63	-15353.21	8453.22	NaN	NaN	NaN	-370.34	-228.42	NaN	NaN	-269.54	-528.73	NaN	8453.22	-8297.02
48	2017	NaN	-2757.27	-256.82	-1595.03	NaN	-347.58	-6150.89	-4294.23	-15401.83	8422.51	NaN	NaN	NaN	-380.85	-238.18	NaN	NaN	-381.17	-520.00	NaN	8422.51	-8499.52
49	2018	NaN	-2845.50	-285.42	-1658.27	NaN	-383.67	-6076.45	-4601.06	-15850.37	8678.62	NaN	NaN	NaN	-292.53	-253.00	NaN	NaN	-360.83	-541.20	NaN	8678.62	-8619.30
50	2019	NaN	-2941.63	-288.07	-1666.62	NaN	-364.89	-6240.70	-4447.23	-15949.15	8783.28	NaN	NaN	NaN	-280.93	-201.14	NaN	NaN	-349.19	-555.25	NaN	8783.28	-8552.38
51	2020	NaN	-4527.85	-209.66	-1522.25	NaN	-387.20	-6570.86	-4917.23	-18135.05	9776.54	NaN	NaN	NaN	-574.53	-203.60	NaN	NaN	-334.39	-571.18	NaN	9776.54	-10042.21
52	2021	NaN	-4266.04	-215.78	-1372.79	NaN	-373.38	-5782.78	-5688.41	-17699.18	9776.97	NaN	NaN	NaN	-561.98	-225.32	NaN	NaN	-394.47	-551.30	NaN	9776.97	-9655.28

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Dash Punctuation

Other Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Interactions

Correlations

Missing values

Sample